SaPendingCharge

Logical Entity Name | SaPendingCharge
Default Table Name | SaPendingCharge
Physical Only | NO
Owner | dbo
Definition |
Note |

SaPendingCharge Columns

ColumnName | Domain | Datatype | NULL | Definition
SaPendingChargeID |  | int | NO |
SyCampusID |  | int | NO |
SyStudentID |  | int | NO |
AdEnrollID |  | int | YES |
AdTermID |  | int | YES |
SaBillCodeID |  | int | NO |
Amount |  | money | NO |
Type |  | char(1) | NO |
Descrip |  | varchar(100) | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdFeesID |  | int | YES |
AdEnrollSchedID |  | int | YES |
Source |  | char(1) | NO |
Discount |  | money | NO |
AdCourseID |  | int | YES |
CourseAmountToRetain |  | money | YES |
SaCourseRefundPolicyID |  | int | YES |
Removed |  | bit | NO |
AdEnrollLessonID |  | int | YES |
AdEnrollSchedExtendID |  | int | YES |
AdClassSchedID |  | int | YES |
FaStudentAyPaymentPeriodId |  | int | YES |
AdTermGroupID |  | int | YES |
RegAdTermID |  | int | YES |
SaTuitionDiscountPolicyID |  | int | YES |

SaPendingCharge Primary and Unique Keys

Key Name | Key Type | Keys
PK_saPendingCharge_saPendingChargeID | PrimaryKey | SaPendingChargeID

SaPendingCharge Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdTerm | Non-Identifying | Zero or One to Zero or More | FK_saPendingCharge.AdTermID_AdTerm.AdTermID |  |  | AdTermID | NO | YES
SaBillCode | Non-Identifying | One To Zero or More | FK_saPendingCharge.SaBillCodeID_SaBillCode.SaBillCodeID |  |  | SaBillCodeID | NO | YES
SyCampus | Non-Identifying | One To Zero or More | FK_saPendingCharge.SyCampusID_SyCampus.SyCampusID |  |  | SyCampusID | NO | YES
syStudent | Non-Identifying | One To Zero or More | FK_saPendingCharge.SyStudentID_SyStudent.SyStudentID |  |  | SyStudentID | NO | YES
AdClassSched | Non-Identifying | Zero or One to Zero or More | Fk_SaPendingCharge_AdClassSchedID_AdClassSched_AdClassSchedID |  |  | AdClassSchedID | NO | YES
AdFees | Non-Identifying | Zero or One to Zero or More | Fk_SaPendingCharge_AdFeesID_AdFees_AdFeesID |  |  | AdFeesID | NO | YES
FaStudentAYPaymentPeriod | Non-Identifying | Zero or One to Zero or More | FK_SaPendingCharge_FaStudentAyPaymentPeriodId_FaStudentAyPaymentPeriod_FaStudentAyPaymentPeriodId |  |  | FaStudentAyPaymentPeriodId | NO | YES
SaTuitionDiscountPolicy | Non-Identifying | Zero or One to Zero or More | FK_SaPendingCharge_SaTuitionDiscountPolicyID_SaTuitionDiscountPolicy_SaTuitionDiscountPolicyID |  |  | SaTuitionDiscountPolicyID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SaPendingCharge_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SaPendingChargeCourseAmount | Non-Identifying | One To Zero or More | FK_SaPendingChargeCourseAmount_SaPendingChargeID_SaPendingCharge_SaPendingChargeID |  |  |  | NO | YES
SsStudentServiceAssociation | Non-Identifying | One To Zero or More | FK_SsStudentServiceAssociation.SaPendingChargeID_SaPendingCharge.SaPendingChargeID |  |  |  | NO | YES

SaPendingCharge Check Constraints

Check Constraint Name | CheckConstraint

SaPendingCharge Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaPendingCharge Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAccountPendingTransaction | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaPendingCharge | NO |  |  |

SaPendingCharge Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | LedgerCard_Billing
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaPendingCharge Data Movement Rules

Name | Type | Rule Text/Value